UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QIoRcnZeVcE7bnGHX9Yne8UyVVgtWeKp5fJnlMbCnus='
WHERE
key_id = '5b06276d4f8e6b1bb9b3534ff9ca3422a0f3398f4e10fb48f183827fe32d5ea5'
AND (
token = 'QIoRcnZeVcE7bnGHX9Yne8UyVVgtWeKp5fJnlMbCnus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)