UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bJWojA17ZbQ6aMy9Foy28PBOVP8j7cLqjNT6cjEman8='
WHERE
key_id = '28a85c98ca4d8e1e33b8b5596ae4544f7e46a6cf87c029f600ea18355a27545d'
AND (
token = 'bJWojA17ZbQ6aMy9Foy28PBOVP8j7cLqjNT6cjEman8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)