UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YrWWuSwWc0top3NHZFwCamuOcMrYXMy7tepybyn1XTs='
WHERE
key_id = 'bf347f9129a6da5d49e33f122b34ccf74833d39257885a45d824500563a2dbaa'
AND (
token = 'YrWWuSwWc0top3NHZFwCamuOcMrYXMy7tepybyn1XTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)