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