UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RtOiq19BLRIjw1iN38k/nNnNfF7fniT9waynESvnigk='
WHERE
key_id = 'a454faf6e4fdb4a8a691852200b3b8137fbb1fa21c5631dee26af53aeded7a0a'
AND (
token = 'RtOiq19BLRIjw1iN38k/nNnNfF7fniT9waynESvnigk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)