UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lpW5uq7shjbII8CN217wND4zNxqQwJSaLdVzwk/qr78='
WHERE
key_id = 'a4ca3ca778b3b31c6584952216a1044bb7297f6c43bc0de9425d330b5a9b3e1d'
AND (
token = 'lpW5uq7shjbII8CN217wND4zNxqQwJSaLdVzwk/qr78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)