UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NDnoidGI1r8GEBpznZNBnPA5rezo9fDOMbiB/Iik6us='
WHERE
key_id = 'c12ea4197ef242cc4e91035fc2bb65dd2e5cbf9d0fa080545aa8e04fb1baf4a5'
AND (
token = 'NDnoidGI1r8GEBpznZNBnPA5rezo9fDOMbiB/Iik6us='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)