UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1VwHs86STDuqa0ZAmdfd0aa8/o9maPI3PlYsD2TAWBA='
WHERE
key_id = '40b00d142059008c275ca8d865f0316278585eff32f9df4526064ecce5b0687d'
AND (
token = '1VwHs86STDuqa0ZAmdfd0aa8/o9maPI3PlYsD2TAWBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)