UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wi9AKYzrdXKYpAWjBlOeszP62Jdxw79E1S9Gh9vPzMg='
WHERE
key_id = 'd97ddff5e91eb3c07d747de00341ddb6fc5a3820f4c30582e3a2bd4de4aae664'
AND (
token = 'wi9AKYzrdXKYpAWjBlOeszP62Jdxw79E1S9Gh9vPzMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)