UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P8y3nnOjhl1xkH74S5iuxXr/L8xc4fMmPB0rvgQlFcA='
WHERE
key_id = 'a3feb89f79165f52b9cbf4a418ca120207fc0915e89f2ab0cff25f2225247e5f'
AND (
token = 'P8y3nnOjhl1xkH74S5iuxXr/L8xc4fMmPB0rvgQlFcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)