UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nj3QKnyBtNuMjqoc+BLS32Z2ky85VdJtNMcz/3uUJs0='
WHERE
key_id = 'c21c4c8f13e8ab162912f34b6a09ae04f40f0e9b7b25aa5e9f0f53dd47adbe14'
AND (
token = 'Nj3QKnyBtNuMjqoc+BLS32Z2ky85VdJtNMcz/3uUJs0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)