UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xx6N4M7ryC1AQvL2XEEMEJzFcH1kQNRX25XCdcJqiBs=' 
WHERE 
  key_id = '977e62e948c413208ca75e6727c4ba7b035606d2907f0b5d8476f4e9f3151aa9' 
  AND (
    token = 'xx6N4M7ryC1AQvL2XEEMEJzFcH1kQNRX25XCdcJqiBs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021