UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hzcZUVK9OwkwSVBzTaANMpkkPcjVfwZLOcIOiKnb1Hc='
WHERE
key_id = 'c718bbff6886111b079fdb3e3bed97332de1d73802913d70779252d5d7f41135'
AND (
token = 'hzcZUVK9OwkwSVBzTaANMpkkPcjVfwZLOcIOiKnb1Hc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)