UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yMZl8ugGO+H/ZrhYg4M6MlBfe1BoWOPZWvJWbL3xZyc='
WHERE
key_id = '0aeaa54415737b0aad8a6593973d4fb23ac30e59c0522c813b785be0a013f927'
AND (
token = 'yMZl8ugGO+H/ZrhYg4M6MlBfe1BoWOPZWvJWbL3xZyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)