UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NgbmXcVq2zkCRD4x7gdvnLd6LzwEg170zdPrckV8dZo='
WHERE
key_id = 'e0ac4f7d46676708a402e419bb9c543c01041ff5f577d495b0bbd9e71d79dc4e'
AND (
token = 'NgbmXcVq2zkCRD4x7gdvnLd6LzwEg170zdPrckV8dZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)