UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZqNN+7svodB+xSYrkJhGT9MraYh8jNnkd+yO18I1YQc='
WHERE
key_id = '4d1bc29ad438478ea3440a7df15136bd02dcfc02dc3e92abf83be461d6540084'
AND (
token = 'ZqNN+7svodB+xSYrkJhGT9MraYh8jNnkd+yO18I1YQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)