UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hi+nCB6PVp7m4uRHkjphASn74wQl7Msl9d29rIS5QIE='
WHERE
key_id = '0b1ddb1081b396613e99c5fb2035b3272f3b3a9e277cf7df78492248c80354f5'
AND (
token = 'hi+nCB6PVp7m4uRHkjphASn74wQl7Msl9d29rIS5QIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)