UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JkBzb7Fo3DaUvq3sGJW4WvDq6sN0n5Sh4yS64pMePI4=' 
WHERE 
  key_id = '77015a6cd9d7ba32ca844543771d9aa02971ac336515978c19ca83bd63d46e74' 
  AND (
    token = 'JkBzb7Fo3DaUvq3sGJW4WvDq6sN0n5Sh4yS64pMePI4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035