UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7WAeHbOAlkmlV6Z5Mh4h4ahIG+mNDqmEYns5GzNgCMo='
WHERE
key_id = 'c43c8554b0ba2900ce8f04bf3c7893223a7bac1776e86f32f5d97cc7195061cf'
AND (
token = '7WAeHbOAlkmlV6Z5Mh4h4ahIG+mNDqmEYns5GzNgCMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)