UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CGx8JM75xl0aZrZxrOyoIE/eydW0G7EMRYgYfH7ec4g='
WHERE
key_id = '9a909d74dca08d8bb8c971008a3929c78ed355c955ea0c080707a6915518c081'
AND (
token = 'CGx8JM75xl0aZrZxrOyoIE/eydW0G7EMRYgYfH7ec4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)