UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fdE7f7Rmee0yj6h4H3JeIi653s3A8BupEoqGU5dljcg='
WHERE
key_id = '194b8bad1cb04dde3fa3870abd335cddba8675196c0dc1fa0047991aa04f0b9d'
AND (
token = 'fdE7f7Rmee0yj6h4H3JeIi653s3A8BupEoqGU5dljcg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)