UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dNbAhxjVCYoG1WnhzIieAk2sAqWIdob+IqV+kenyx+4='
WHERE
key_id = '272c52708bde9ba57206e4b9b627e4cac0007e601b570d40a0426cd8d5904615'
AND (
token = 'dNbAhxjVCYoG1WnhzIieAk2sAqWIdob+IqV+kenyx+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)