UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XcoUUOdqiBnEWZxtaXyInlEQA6OXrE1WO1yAKcbsRyQ='
WHERE
key_id = '8bb50d03c0c24296a4ed694530f3a38ff566a9db1d8ead0f8a9679b4879e50e6'
AND (
token = 'XcoUUOdqiBnEWZxtaXyInlEQA6OXrE1WO1yAKcbsRyQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)