UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q8ftkBNK5mbtOa82hOmk+DgaZw1EKj8vLbkFfsCVMlw='
WHERE
key_id = 'f82577b1ecac4e5398d3f3cbeec8f1173d447fa0165eb1fd81414b4f3b08b7b3'
AND (
token = 'q8ftkBNK5mbtOa82hOmk+DgaZw1EKj8vLbkFfsCVMlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)