UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D9lNMTFC6AiINjBUVuC0e6rX9V7p/bLrl1MTq1mHojM='
WHERE
key_id = 'b08fa141b0518f3cc721a313f1f8ad674c4f210930550208058c1c39145d1cc7'
AND (
token = 'D9lNMTFC6AiINjBUVuC0e6rX9V7p/bLrl1MTq1mHojM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)