UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pGuqTfaB5uJp6LVMVlGVE8Yw27kY8gcVMNHsO5Q3FMU='
WHERE
key_id = '2e405800d139f9eabc19f888ed861bbaeb54af9af8cfa4d025670a9c87d3b857'
AND (
token = 'pGuqTfaB5uJp6LVMVlGVE8Yw27kY8gcVMNHsO5Q3FMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)