UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KOog67BDtOS4tNDBOq/lClfZhnHE49WIrlaAvNBhPCA='
WHERE
key_id = '77f49b379199110a6ab995ad568db97fe4ae62510984019f866025ced00a63df'
AND (
token = 'KOog67BDtOS4tNDBOq/lClfZhnHE49WIrlaAvNBhPCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)