UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cnTOKeIh8ozEyb7YNCOoelZzAch9oVdJf3FXR3Ur6Jo='
WHERE
key_id = '3791389ec07b62bd3f749aaf272dcac0a12b274fb69016fec54a664deaa6a5fe'
AND (
token = 'cnTOKeIh8ozEyb7YNCOoelZzAch9oVdJf3FXR3Ur6Jo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)