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