UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pdpz3ji86GKIw2k3WGT4grqLwSgGGph2z9OoHlgAd54='
WHERE
key_id = '7f3d874c722384b0e5c0f75f1eaf5599ea92d02f009320d4627fe4a3bafd3921'
AND (
token = 'pdpz3ji86GKIw2k3WGT4grqLwSgGGph2z9OoHlgAd54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)