UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z+p80b+14camsxyi3WERdtPqgSlmws834BK8B9DGa6A='
WHERE
key_id = 'f80f688287d98eccdad4f0cfa44e455eeba0df33056c182f0f63adcf9c736763'
AND (
token = 'z+p80b+14camsxyi3WERdtPqgSlmws834BK8B9DGa6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)