UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zE5dKuQjsvZj7RTyPrW7dB4bdP83CnJwbuGIu9SJ6Nc='
WHERE
key_id = '834a7455b9d9b42337ec67856fc3687e1aba8d417fac553bc593856b87a04d84'
AND (
token = 'zE5dKuQjsvZj7RTyPrW7dB4bdP83CnJwbuGIu9SJ6Nc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)