UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h7S9TYzymXlIGUs8OuT8o8dqVVuMCp6q1GpHGVMNWPg='
WHERE
key_id = '12a12679dc53570453bd31052fb7cd4910b5d9c5f62ec0cb7e40eb4a63f95b48'
AND (
token = 'h7S9TYzymXlIGUs8OuT8o8dqVVuMCp6q1GpHGVMNWPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)