UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZyQi0wss58QHXlZS6NXgykUjmfQwkEjR2sDi+QXLiU0='
WHERE
key_id = 'aa8cba0cc74ab2e28dbdbcdfe6738c12dd73f717604565aa23ec3a86d8cb8d4b'
AND (
token = 'ZyQi0wss58QHXlZS6NXgykUjmfQwkEjR2sDi+QXLiU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)