UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z+BEphCbd34GM6IuMpAAaEpsZijRm2cdTEHax+f8Agw='
WHERE
key_id = '393b6de11ac494b18ff9fc91d4fcdc9191a0fd560581317a4d54d24d6adb0559'
AND (
token = 'Z+BEphCbd34GM6IuMpAAaEpsZijRm2cdTEHax+f8Agw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)