UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jYf71hartpxV4sBMe1mK6MPRo+0aWiA7xlHAEU6GDTA=' 
WHERE 
  key_id = '09fe60b68c16c6970f63ee32c404e70e6bec54ef4fc7e79595771cb861d6169a' 
  AND (
    token = 'jYf71hartpxV4sBMe1mK6MPRo+0aWiA7xlHAEU6GDTA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044