UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZbAXVaV2d7p1H/vJ3/xlsLkfs/SzsFExRJGg3FxMOgw='
WHERE
key_id = 'ebca1540d42a10cc766dc811bd4645390cbe208a507e3470a4a16b8e85ebf94e'
AND (
token = 'ZbAXVaV2d7p1H/vJ3/xlsLkfs/SzsFExRJGg3FxMOgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)