UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'paE+BgSlPGpHORgYz2QTii2cr+hIapNCPr0/V33vicE=' 
WHERE 
  key_id = '65d3bf50166e5412d57553c0e36785cb29f1a8b8fe98d067a2b774dd4b26f68e' 
  AND (
    token = 'paE+BgSlPGpHORgYz2QTii2cr+hIapNCPr0/V33vicE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039