UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dAzruGTTWv2qaPMrNYMLXCWrYM/DCOvQnHcP9GvxYUk='
WHERE
key_id = '9d33f9831711322a7bdd9ed3d0ed832941d0c00757a2fbea9c5c322ce5ca5198'
AND (
token = 'dAzruGTTWv2qaPMrNYMLXCWrYM/DCOvQnHcP9GvxYUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)